{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Reconciliation","FSU_AUX_BILL_NOT_INV","FSU_AUX_BILL_INV_RVW"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,1,6,10]]}
[]
[]
[]
["Auxiliary Billing Reconciliation Template"]
[]
["Document Purpose: ","This workbook is a template for selling auxiliaries to reconcile their billable data in OMNI Financials (FI) with their sales records. Contact Auxiliary Services at the email below for assistance. "]
[]
[]
["Role Required: ","FSU_AUX_BILLING"]
[]
["Questions? ","ctl-auxiliaryaccounting@fsu.edu"]
[]
["To Complete Reconciliation:","1. Identify Bills Not Yet Invoiced in OMNI FI"]
[null,"Run OMNI FI query FSU_AUX_BILL_NOT_INV to Excel for the month being reconciled."]
[null,"Paste results into the FSU_AUX_BILL_NOT_INV tab."]
[]
[null,"2. Identify Bills Invoiced in OMNI FI"]
[null,"Run OMNI FI query FSU_AUX_BILL_INV_RVW to Excel for the month being reconciled."]
[null,"Paste results into the FSU_AUX_BILL_INV_RVW tab."]
[]
[null,"3. Obtain Original Sales Records"]
[null,"Input original sales data into the Reconciliation tab."]
[]
[null,"4. Compare Sales Records Agree to OMNI FI Billing Data"]
[null,"Review bottom line to verify original sales records agree to billing data in OMNI FI."]
[null,"Research any resolve any discrepancies."]
[]
[null,"5. Save the File"]
[null,"Complete the header portion of the workbook for the month being reconciled."]
[null,"Save the file and maintain copy in department reconciliation records."]

{"sheet":"Reconciliation","index":1,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Auxiliary Billing Month End Reconciliation"]
[]
["Period:"]
["Fiscal Year: "]
["Preparer: "]
["Prepared Date:"]
[]
[]
["Original Sales Record",{"$f":"B10+B11+B12","v":0}]
["Internal",null,"<- Input sales records here"]
["External",null,"<- Input sales records here"]
["Component",null,"<- Input sales records here"]
[null,0]
[]
["Bills Not Invoiced",{"$f":"SUM(FSU_AUX_BILL_NOT_INV!X:X)","v":0}]
["Internal ",{"$f":"SUMIFS(FSU_AUX_BILL_NOT_INV!X:X,FSU_AUX_BILL_NOT_INV!AF:AF,\"INTERNAL\")","v":0}]
["External",{"$f":"SUMIFS(FSU_AUX_BILL_NOT_INV!X:X,FSU_AUX_BILL_NOT_INV!AF:AF,\"EXTERNAL\")","v":0}]
["Component",{"$f":"SUMIFS(FSU_AUX_BILL_NOT_INV!X:X,FSU_AUX_BILL_NOT_INV!AF:AF,\"COMPONENT\")","v":0}]
[null,{"$f":"B15-B16-B17-B18","v":0}]
[]
["Bills Invoiced",{"$f":"SUM(FSU_AUX_BILL_INV_RVW!X:X)","v":0}]
["Internal",{"$f":"SUMIFS(FSU_AUX_BILL_INV_RVW!X:X,FSU_AUX_BILL_INV_RVW!AK:AK,\"INTERNAL\")","v":0}]
["External",{"$f":"SUMIFS(FSU_AUX_BILL_INV_RVW!X:X,FSU_AUX_BILL_INV_RVW!AK:AK,\"EXTERNAL\")","v":0}]
["Component",{"$f":"SUMIFS(FSU_AUX_BILL_INV_RVW!X:X,FSU_AUX_BILL_INV_RVW!AK:AK,\"COMPONENT\")","v":0}]
[null,{"$f":"B21-B22-B23-B24","v":0}]
[]
["Reconciliation",{"$f":"B9-B15-B21","v":0}]

{"sheet":"FSU_AUX_BILL_NOT_INV","index":2,"n_rows":1,"n_cols":45,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Business Unit","Bill Source","Auxiliary","Billing Specialist","Bill Status","Invoice","Invoice Line","Adjusted","Prior Invoice","Rebill Invoice","Latest Invoice","Customer ID","Customer Name 1","Customer Name 2","Charge From Date","Charge To Date","Identifier","Charge Description","Long Note","Unit of Measure","Quantity","Unit Price","Gross Amount","Net Amount","Bill Header PO","Bill Line PO","PO Line","Date Time Added","User","Last Update","Last User","Customer Group","Account","Dept","Fund","ChartField 1","ChartField 2","ChartField 3","Media (A=Email/P=Print)","Template Bill (Y/N)","Template Bill ID","Project ID (Blank)","Accounting Date (Blank)","Invoice Date (Blank)","Date Invoiced (Blank)"]

{"sheet":"FSU_AUX_BILL_INV_RVW","index":3,"n_rows":1,"n_cols":45,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Unit","Invoice","Invoice Line","Customer ID","Sequence","Customer Name","Customer Name 2","Status","Adjusted","Adjusted","Adjusting","Latest","Source","Biller","Chg From","Chg To","ID","Descr","Long Note","UOM","Qty","Unit Price","Gross","Net","Descr","Date","Acctg Date","Dt Invoice","Bill Header PO","Bill Line PO","Line Item","Dtime Add","Last Updt","Last OPRID","User","Product","Cust Group","Dept","Fund","Account","ChartField 1","ChartField 2","ChartField 3","Media","Project"]